Pandas Profile _traffic

Dataset statistics

Number of variables	25
Number of observations	460556
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	87.8 MiB
Average record size in memory	200.0 B

Variable types

Numeric	11
Categorical	13
DateTime	1

Warnings

`lifecycle:transition` has constant value "complete"	Constant
`matricola` has constant value "0.0"	Constant
`org:resource` has a high cardinality: 148 distinct values	High cardinality
`case:concept:name` has a high cardinality: 129615 distinct values	High cardinality
`totalPaymentAmount` is highly correlated with `paymentAmount`	High correlation
`paymentAmount` is highly correlated with `totalPaymentAmount`	High correlation
`timesincemidnight` is highly correlated with `hour`	High correlation
`hour` is highly correlated with `timesincemidnight`	High correlation
`timesincemidnight` is highly correlated with `hour` and 2 other fields	High correlation
`dismissal` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`notificationType` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`hour` is highly correlated with `timesincemidnight` and 2 other fields	High correlation
`article` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`lifecycle:transition` is highly correlated with `timesincemidnight` and 9 other fields	High correlation
`vehicleClass` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`matricola` is highly correlated with `timesincemidnight` and 9 other fields	High correlation
`concept:name` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`label` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`lastSent` is highly correlated with `lifecycle:transition` and 1 other fields	High correlation
`case:concept:name` is uniformly distributed	Uniform
`totalPaymentAmount` has 383320 (83.2%) zeros	Zeros
`points` has 445503 (96.7%) zeros	Zeros
`expense` has 186095 (40.4%) zeros	Zeros
`paymentAmount` has 383321 (83.2%) zeros	Zeros
`weekday` has 73350 (15.9%) zeros	Zeros
`timesincelastevent` has 141493 (30.7%) zeros	Zeros
`timesincecasestart` has 139927 (30.4%) zeros	Zeros

Reproduction

Analysis started	2021-03-23 07:54:10.611623
Analysis finished	2021-03-23 07:55:59.782810
Duration	1 minute and 49.17 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

amount
Real number (ℝ_≥0)

Distinct	204
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	59.27446406
Minimum	0
Maximum	8000
Zeros	111
Zeros (%)	< 0.1%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	23
Q1	33.6
median	36
Q3	68.77
95-th percentile	143
Maximum	8000
Range	8000
Interquartile range (IQR)	35.17

Descriptive statistics

Standard deviation	83.15059319
Coefficient of variation (CV)	1.402806327
Kurtosis	1085.624752
Mean	59.27446406
Median Absolute Deviation (MAD)	4
Skewness	19.66363976
Sum	27299210.07
Variance	6914.021148
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35	56158	12.2%
33.6	41682	9.1%
36	40830	8.9%
38	31870	6.9%
31.3	30434	6.6%
32.8	23687	5.1%
32	20126	4.4%
39	18424	4.0%
71.5	16704	3.6%
74	15892	3.5%
Other values (194)	164749	35.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	111	< 0.1%
18.78	3811	0.8%
19	1570	0.3%
19.68	2988	0.6%
19.95	2454	0.5%

Value	Count	Frequency (%)
8000	3	< 0.1%
7546	2	< 0.1%
4351	3	< 0.1%
4000	4	< 0.1%
3684.5	7	< 0.1%

org:resource
Categorical

HIGH CARDINALITY

Distinct	148
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

538.0	27429
550.0	24515
541.0	21934
537.0	21175
559.0	17749
Other values (143)	347754

Length

Max length	5
Median length	5
Mean length	4.655681394
Min length	3

Characters and Unicode

Total characters	2144202
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	561.0
2nd row	561.0
3rd row	561.0
4th row	561.0
5th row	561.0

Value	Count	Frequency (%)
538.0	27429	6.0%
550.0	24515	5.3%
541.0	21934	4.8%
537.0	21175	4.6%
559.0	17749	3.9%
536.0	15423	3.3%
557.0	15152	3.3%
49.0	13710	3.0%
561.0	10980	2.4%
558.0	10677	2.3%
Other values (138)	281812	61.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
538.0	27429	6.0%
550.0	24515	5.3%
541.0	21934	4.8%
537.0	21175	4.6%
559.0	17749	3.9%
536.0	15423	3.3%
557.0	15152	3.3%
49.0	13710	3.0%
561.0	10980	2.4%
558.0	10677	2.3%
Other values (138)	281812	61.2%

Most occurring characters

Value	Count	Frequency (%)
0	536822	25.0%
.	460547	21.5%
5	361448	16.9%
8	162446	7.6%
3	134524	6.3%
4	115253	5.4%
6	91436	4.3%
1	83819	3.9%
2	77651	3.6%
7	60630	2.8%
Other values (6)	59626	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1683610	78.5%
Other Punctuation	460547	21.5%
Lowercase Letter	45	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
0	536822	31.9%
5	361448	21.5%
8	162446	9.6%
3	134524	8.0%
4	115253	6.8%
6	91436	5.4%
1	83819	5.0%
2	77651	4.6%
7	60630	3.6%
9	59581	3.5%

Value	Count	Frequency (%)
o	9	20.0%
t	9	20.0%
h	9	20.0%
e	9	20.0%
r	9	20.0%

Value	Count	Frequency (%)
.	460547	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2144157	> 99.9%
Latin	45	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
0	536822	25.0%
.	460547	21.5%
5	361448	16.9%
8	162446	7.6%
3	134524	6.3%
4	115253	5.4%
6	91436	4.3%
1	83819	3.9%
2	77651	3.6%
7	60630	2.8%

Value	Count	Frequency (%)
o	9	20.0%
t	9	20.0%
h	9	20.0%
e	9	20.0%
r	9	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2144202	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	536822	25.0%
.	460547	21.5%
5	361448	16.9%
8	162446	7.6%
3	134524	6.3%
4	115253	5.4%
6	91436	4.3%
1	83819	3.9%
2	77651	3.6%
7	60630	2.8%
Other values (6)	59626	2.8%

dismissal
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

NIL	458332
#	2030
G	105
@	37
D	17
Other values (3)	35

Length

Max length	5
Median length	3
Mean length	2.99044633
Min length	1

Characters and Unicode

Total characters	1377268
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NIL
2nd row	NIL
3rd row	NIL
4th row	NIL
5th row	NIL

Value	Count	Frequency (%)
NIL	458332	99.5%
#	2030	0.4%
G	105	< 0.1%
@	37	< 0.1%
D	17	< 0.1%
other	12	< 0.1%
C	12	< 0.1%
4	11	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
nil	458332	99.5%
	2067	0.4%
g	105	< 0.1%
d	17	< 0.1%
other	12	< 0.1%
c	12	< 0.1%
4	11	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	458332	33.3%
I	458332	33.3%
L	458332	33.3%
#	2030	0.1%
G	105	< 0.1%
@	37	< 0.1%
D	17	< 0.1%
C	12	< 0.1%
o	12	< 0.1%
t	12	< 0.1%
Other values (4)	47	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1375130	99.8%
Other Punctuation	2067	0.2%
Lowercase Letter	60	< 0.1%
Decimal Number	11	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
N	458332	33.3%
I	458332	33.3%
L	458332	33.3%
G	105	< 0.1%
D	17	< 0.1%
C	12	< 0.1%

Value	Count	Frequency (%)
o	12	20.0%
t	12	20.0%
h	12	20.0%
e	12	20.0%
r	12	20.0%

Value	Count	Frequency (%)
#	2030	98.2%
@	37	1.8%

Value	Count	Frequency (%)
4	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1375190	99.8%
Common	2078	0.2%

Most frequent character per script

Value	Count	Frequency (%)
N	458332	33.3%
I	458332	33.3%
L	458332	33.3%
G	105	< 0.1%
D	17	< 0.1%
C	12	< 0.1%
o	12	< 0.1%
t	12	< 0.1%
h	12	< 0.1%
e	12	< 0.1%

Value	Count	Frequency (%)
#	2030	97.7%
@	37	1.8%
4	11	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1377268	100.0%

Most frequent character per block

Value	Count	Frequency (%)
N	458332	33.3%
I	458332	33.3%
L	458332	33.3%
#	2030	0.1%
G	105	< 0.1%
@	37	< 0.1%
D	17	< 0.1%
C	12	< 0.1%
o	12	< 0.1%
t	12	< 0.1%
Other values (4)	47	< 0.1%

concept:name
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

Create Fine	129615
Send Fine	83232
Insert Fine Notification	79860
Add penalty	79860
Payment	77237
Other values (5)	10752

Length

Max length	37
Median length	11
Mean length	12.6400264
Min length	7

Characters and Unicode

Total characters	5821440
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Create Fine
2nd row	Send Fine
3rd row	Insert Fine Notification
4th row	Add penalty
5th row	Create Fine

Value	Count	Frequency (%)
Create Fine	129615	28.1%
Send Fine	83232	18.1%
Insert Fine Notification	79860	17.3%
Add penalty	79860	17.3%
Payment	77237	16.8%
Insert Date Appeal to Prefecture	4184	0.9%
Send Appeal to Prefecture	4121	0.9%
Receive Result Appeal from Prefecture	999	0.2%
Notify Result Appeal to Offender	896	0.2%
Appeal to Judge	552	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
fine	292707	30.8%
create	129615	13.6%
send	87353	9.2%
insert	84044	8.8%
notification	79860	8.4%
penalty	79860	8.4%
add	79860	8.4%
payment	77237	8.1%
appeal	10752	1.1%
to	9753	1.0%
Other values (8)	19725	2.1%

Most occurring characters

Value	Count	Frequency (%)
e	930515	16.0%
n	701957	12.1%
t	556508	9.6%
i	534182	9.2%
	490210	8.4%
a	381508	6.6%
F	292707	5.0%
d	248521	4.3%
r	234162	4.0%
o	171368	2.9%
Other values (20)	1279802	22.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4471076	76.8%
Uppercase Letter	860154	14.8%
Space Separator	490210	8.4%

Most frequent character per category

Value	Count	Frequency (%)
e	930515	20.8%
n	701957	15.7%
t	556508	12.4%
i	534182	11.9%
a	381508	8.5%
d	248521	5.6%
r	234162	5.2%
o	171368	3.8%
y	157993	3.5%
p	101364	2.3%
Other values (8)	452998	10.1%

Value	Count	Frequency (%)
F	292707	34.0%
C	129615	15.1%
A	90612	10.5%
S	87353	10.2%
P	86541	10.1%
I	84044	9.8%
N	80756	9.4%
D	4184	0.5%
R	2894	0.3%
O	896	0.1%

Value	Count	Frequency (%)
	490210	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5331230	91.6%
Common	490210	8.4%

Most frequent character per script

Value	Count	Frequency (%)
e	930515	17.5%
n	701957	13.2%
t	556508	10.4%
i	534182	10.0%
a	381508	7.2%
F	292707	5.5%
d	248521	4.7%
r	234162	4.4%
o	171368	3.2%
y	157993	3.0%
Other values (19)	1121809	21.0%

Value	Count	Frequency (%)
	490210	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5821440	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	930515	16.0%
n	701957	12.1%
t	556508	9.6%
i	534182	9.2%
	490210	8.4%
a	381508	6.6%
F	292707	5.0%
d	248521	4.3%
r	234162	4.0%
o	171368	2.9%
Other values (20)	1279802	22.0%

vehicleClass
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

A	447633
C	8524
M	4391
R	8

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	460556
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Value	Count	Frequency (%)
A	447633	97.2%
C	8524	1.9%
M	4391	1.0%
R	8	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
a	447633	97.2%
c	8524	1.9%
m	4391	1.0%
r	8	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	447633	97.2%
C	8524	1.9%
M	4391	1.0%
R	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	460556	100.0%

Most frequent character per category

Value	Count	Frequency (%)
A	447633	97.2%
C	8524	1.9%
M	4391	1.0%
R	8	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	460556	100.0%

Most frequent character per script

Value	Count	Frequency (%)
A	447633	97.2%
C	8524	1.9%
M	4391	1.0%
R	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	460556	100.0%

Most frequent character per block

Value	Count	Frequency (%)
A	447633	97.2%
C	8524	1.9%
M	4391	1.0%
R	8	< 0.1%

totalPaymentAmount
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1006
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.789659347
Minimum	0
Maximum	4021
Zeros	383320
Zeros (%)	83.2%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	46
Maximum	4021
Range	4021
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	27.35406785
Coefficient of variation (CV)	3.112073719
Kurtosis	1234.297158
Mean	8.789659347
Median Absolute Deviation (MAD)	0
Skewness	15.68362497
Sum	4048130.35
Variance	748.2450282
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	383320	83.2%
35	10693	2.3%
36	7200	1.6%
33.6	6341	1.4%
38	5772	1.3%
39	4146	0.9%
31.3	2949	0.6%
32.8	2449	0.5%
32	2294	0.5%
46	1680	0.4%
Other values (996)	33712	7.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	383320	83.2%
1.32	1	< 0.1%
1.54	1	< 0.1%
3.28	2	< 0.1%
3.36	1	< 0.1%

Value	Count	Frequency (%)
4021	1	< 0.1%
1842	1	< 0.1%
1597	1	< 0.1%
1520	1	< 0.1%
1498.5	1	< 0.1%

lifecycle:transition
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

complete	460556

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	3684448
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	complete
2nd row	complete
3rd row	complete
4th row	complete
5th row	complete

Value	Count	Frequency (%)
complete	460556	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	460556	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	921112	25.0%
c	460556	12.5%
o	460556	12.5%
m	460556	12.5%
p	460556	12.5%
l	460556	12.5%
t	460556	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3684448	100.0%

Most frequent character per category

Value	Count	Frequency (%)
e	921112	25.0%
c	460556	12.5%
o	460556	12.5%
m	460556	12.5%
p	460556	12.5%
l	460556	12.5%
t	460556	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3684448	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	921112	25.0%
c	460556	12.5%
o	460556	12.5%
m	460556	12.5%
p	460556	12.5%
l	460556	12.5%
t	460556	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3684448	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	921112	25.0%
c	460556	12.5%
o	460556	12.5%
m	460556	12.5%
p	460556	12.5%
l	460556	12.5%
t	460556	12.5%

time:timestamp
Date

Distinct	4903
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

Minimum	1999-12-31 23:00:00+00:00
Maximum	2013-06-17 22:00:00+00:00

Histogram

Histogram with fixed size bins (bins=50)

article
Categorical

HIGH CORRELATION

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

157.0	200873
7.0	127905
158.0	84174
142.0	23250
180.0	4038
Other values (45)	20316

Length

Max length	5
Median length	5
Mean length	4.429891262
Min length	3

Characters and Unicode

Total characters	2040213
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	157.0
2nd row	157.0
3rd row	157.0
4th row	157.0
5th row	157.0

Value	Count	Frequency (%)
157.0	200873	43.6%
7.0	127905	27.8%
158.0	84174	18.3%
142.0	23250	5.0%
180.0	4038	0.9%
181.0	3503	0.8%
80.0	2378	0.5%
171.0	2326	0.5%
172.0	1781	0.4%
146.0	1348	0.3%
Other values (40)	8980	1.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
157.0	200873	43.6%
7.0	127905	27.8%
158.0	84174	18.3%
142.0	23250	5.0%
180.0	4038	0.9%
181.0	3503	0.8%
80.0	2378	0.5%
171.0	2326	0.5%
172.0	1781	0.4%
146.0	1348	0.3%
Other values (40)	8980	1.9%

Most occurring characters

Value	Count	Frequency (%)
0	468296	23.0%
.	460493	22.6%
1	333779	16.4%
7	333721	16.4%
5	285898	14.0%
8	94483	4.6%
4	28427	1.4%
2	27139	1.3%
3	3701	0.2%
9	2163	0.1%
Other values (6)	2113	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1579405	77.4%
Other Punctuation	460493	22.6%
Lowercase Letter	315	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
0	468296	29.7%
1	333779	21.1%
7	333721	21.1%
5	285898	18.1%
8	94483	6.0%
4	28427	1.8%
2	27139	1.7%
3	3701	0.2%
9	2163	0.1%
6	1798	0.1%

Value	Count	Frequency (%)
o	63	20.0%
t	63	20.0%
h	63	20.0%
e	63	20.0%
r	63	20.0%

Value	Count	Frequency (%)
.	460493	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2039898	> 99.9%
Latin	315	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
0	468296	23.0%
.	460493	22.6%
1	333779	16.4%
7	333721	16.4%
5	285898	14.0%
8	94483	4.6%
4	28427	1.4%
2	27139	1.3%
3	3701	0.2%
9	2163	0.1%

Value	Count	Frequency (%)
o	63	20.0%
t	63	20.0%
h	63	20.0%
e	63	20.0%
r	63	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2040213	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	468296	23.0%
.	460493	22.6%
1	333779	16.4%
7	333721	16.4%
5	285898	14.0%
8	94483	4.6%
4	28427	1.4%
2	27139	1.3%
3	3701	0.2%
9	2163	0.1%
Other values (6)	2113	0.1%

points
Real number (ℝ_≥0)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1104773361
Minimum	0
Maximum	10
Zeros	445503
Zeros (%)	96.7%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.68429259
Coefficient of variation (CV)	6.193963524
Kurtosis	66.47490183
Mean	0.1104773361
Median Absolute Deviation (MAD)	0
Skewness	7.569668316
Sum	50881
Variance	0.4682563487
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	445503	96.7%
2	8553	1.9%
5	4627	1.0%
6	798	0.2%
3	606	0.1%
10	300	0.1%
8	97	< 0.1%
4	62	< 0.1%
1	10	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	445503	96.7%
1	10	< 0.1%
2	8553	1.9%
3	606	0.1%
4	62	< 0.1%

Value	Count	Frequency (%)
10	300	0.1%
8	97	< 0.1%
6	798	0.2%
5	4627	1.0%
4	62	< 0.1%

case:concept:name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	129615
Distinct (%)	28.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

C20817	20
C17607	17
V8169	17
C10852	16
C19108	16
Other values (129610)	460470

Length

Max length	7
Median length	6
Mean length	6.197980267
Min length	2

Characters and Unicode

Total characters	2854517
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A100
2nd row	A100
3rd row	A100
4th row	A100
5th row	A10000

Value	Count	Frequency (%)
C20817	20	< 0.1%
C17607	17	< 0.1%
V8169	17	< 0.1%
C10852	16	< 0.1%
C19108	16	< 0.1%
V9576	15	< 0.1%
C13062	15	< 0.1%
C18190	15	< 0.1%
V11249	14	< 0.1%
V18853	14	< 0.1%
Other values (129605)	460397	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
c20817	20	< 0.1%
v8169	17	< 0.1%
c17607	17	< 0.1%
c10852	16	< 0.1%
c19108	16	< 0.1%
c13062	15	< 0.1%
v9576	15	< 0.1%
c18190	15	< 0.1%
v18853	14	< 0.1%
v11249	14	< 0.1%
Other values (129605)	460397	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	365782	12.8%
2	242301	8.5%
6	234259	8.2%
4	234136	8.2%
5	232659	8.2%
3	232328	8.1%
7	228071	8.0%
8	217977	7.6%
S	209594	7.3%
9	209537	7.3%
Other values (7)	447873	15.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2393961	83.9%
Uppercase Letter	460556	16.1%

Most frequent character per category

Value	Count	Frequency (%)
1	365782	15.3%
2	242301	10.1%
6	234259	9.8%
4	234136	9.8%
5	232659	9.7%
3	232328	9.7%
7	228071	9.5%
8	217977	9.1%
9	209537	8.8%
0	196911	8.2%

Value	Count	Frequency (%)
S	209594	45.5%
N	139455	30.3%
A	64076	13.9%
V	23183	5.0%
C	16823	3.7%
P	7328	1.6%
L	97	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	2393961	83.9%
Latin	460556	16.1%

Most frequent character per script

Value	Count	Frequency (%)
1	365782	15.3%
2	242301	10.1%
6	234259	9.8%
4	234136	9.8%
5	232659	9.7%
3	232328	9.7%
7	228071	9.5%
8	217977	9.1%
9	209537	8.8%
0	196911	8.2%

Value	Count	Frequency (%)
S	209594	45.5%
N	139455	30.3%
A	64076	13.9%
V	23183	5.0%
C	16823	3.7%
P	7328	1.6%
L	97	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2854517	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	365782	12.8%
2	242301	8.5%
6	234259	8.2%
4	234136	8.2%
5	232659	8.2%
3	232328	8.1%
7	228071	8.0%
8	217977	7.6%
S	209594	7.3%
9	209537	7.3%
Other values (7)	447873	15.7%

expense
Real number (ℝ_≥0)

ZEROS

Distinct	84
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.415624962
Minimum	0
Maximum	60
Zeros	186095
Zeros (%)	40.4%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10
Q3	13.5
95-th percentile	16.6
Maximum	60
Range	60
Interquartile range (IQR)	13.5

Descriptive statistics

Standard deviation	6.714056052
Coefficient of variation (CV)	0.9053931511
Kurtosis	-0.8927615652
Mean	7.415624962
Median Absolute Deviation (MAD)	5
Skewness	0.1981031616
Sum	3415310.57
Variance	45.07854867
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	186095	40.4%
13.5	47123	10.2%
11	43381	9.4%
10	23281	5.1%
13	22892	5.0%
6.71	22858	5.0%
15	20225	4.4%
14.25	15411	3.3%
6.46	15109	3.3%
15.16	12473	2.7%
Other values (74)	51708	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	186095	40.4%
4.96	15	< 0.1%
5.6	18	< 0.1%
5.88	3	< 0.1%
6.46	15109	3.3%

Value	Count	Frequency (%)
60	3	< 0.1%
46	3	< 0.1%
45	51	< 0.1%
40	14	< 0.1%
35	124	< 0.1%

notificationType
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

missing	263132
P	196977
C	447

Length

Max length	7
Median length	7
Mean length	4.428013097
Min length	1

Characters and Unicode

Total characters	2039348
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	missing
2nd row	missing
3rd row	P
4th row	P
5th row	missing

Value	Count	Frequency (%)
missing	263132	57.1%
P	196977	42.8%
C	447	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
missing	263132	57.1%
p	196977	42.8%
c	447	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	526264	25.8%
s	526264	25.8%
m	263132	12.9%
n	263132	12.9%
g	263132	12.9%
P	196977	9.7%
C	447	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1841924	90.3%
Uppercase Letter	197424	9.7%

Most frequent character per category

Value	Count	Frequency (%)
i	526264	28.6%
s	526264	28.6%
m	263132	14.3%
n	263132	14.3%
g	263132	14.3%

Value	Count	Frequency (%)
P	196977	99.8%
C	447	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2039348	100.0%

Most frequent character per script

Value	Count	Frequency (%)
i	526264	25.8%
s	526264	25.8%
m	263132	12.9%
n	263132	12.9%
g	263132	12.9%
P	196977	9.7%
C	447	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2039348	100.0%

Most frequent character per block

Value	Count	Frequency (%)
i	526264	25.8%
s	526264	25.8%
m	263132	12.9%
n	263132	12.9%
g	263132	12.9%
P	196977	9.7%
C	447	< 0.1%

lastSent
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

missing	267269
P	117862
N	71767
C	3658

Length

Max length	7
Median length	7
Mean length	4.481908823
Min length	1

Characters and Unicode

Total characters	2064170
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	missing
2nd row	missing
3rd row	P
4th row	P
5th row	missing

Value	Count	Frequency (%)
missing	267269	58.0%
P	117862	25.6%
N	71767	15.6%
C	3658	0.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
missing	267269	58.0%
p	117862	25.6%
n	71767	15.6%
c	3658	0.8%

Most occurring characters

Value	Count	Frequency (%)
i	534538	25.9%
s	534538	25.9%
m	267269	12.9%
n	267269	12.9%
g	267269	12.9%
P	117862	5.7%
N	71767	3.5%
C	3658	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1870883	90.6%
Uppercase Letter	193287	9.4%

Most frequent character per category

Value	Count	Frequency (%)
i	534538	28.6%
s	534538	28.6%
m	267269	14.3%
n	267269	14.3%
g	267269	14.3%

Value	Count	Frequency (%)
P	117862	61.0%
N	71767	37.1%
C	3658	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2064170	100.0%

Most frequent character per script

Value	Count	Frequency (%)
i	534538	25.9%
s	534538	25.9%
m	267269	12.9%
n	267269	12.9%
g	267269	12.9%
P	117862	5.7%
N	71767	3.5%
C	3658	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2064170	100.0%

Most frequent character per block

Value	Count	Frequency (%)
i	534538	25.9%
s	534538	25.9%
m	267269	12.9%
n	267269	12.9%
g	267269	12.9%
P	117862	5.7%
N	71767	3.5%
C	3658	0.2%

paymentAmount
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1000
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.790931809
Minimum	0
Maximum	3975
Zeros	383321
Zeros (%)	83.2%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	39.51
Maximum	3975
Range	3975
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	23.70380841
Coefficient of variation (CV)	3.042486956
Kurtosis	1915.539696
Mean	7.790931809
Median Absolute Deviation (MAD)	0
Skewness	18.10141562
Sum	3588160.39
Variance	561.8705329
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	383321	83.2%
35	10705	2.3%
36	7204	1.6%
33.6	6344	1.4%
38	6197	1.3%
39	4149	0.9%
31.3	3148	0.7%
32.8	2607	0.6%
32	2293	0.5%
46	1482	0.3%
Other values (990)	33106	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	383321	83.2%
0.2	1	< 0.1%
0.44	18	< 0.1%
0.45	2	< 0.1%
0.5	1	< 0.1%

Value	Count	Frequency (%)
3975	1	< 0.1%
1597	1	< 0.1%
1498.5	1	< 0.1%
1433.5	1	< 0.1%
1064	1	< 0.1%

matricola
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

0.0	460556

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1381668
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	460556	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	460556	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	921112	66.7%
.	460556	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	921112	66.7%
Other Punctuation	460556	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	921112	100.0%

Value	Count	Frequency (%)
.	460556	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1381668	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	921112	66.7%
.	460556	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1381668	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	921112	66.7%
.	460556	33.3%

timesincemidnight
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

1320.0	277629
1380.0	182927

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	2763336
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1320.0
2nd row	1380.0
3rd row	1380.0
4th row	1380.0
5th row	1380.0

Value	Count	Frequency (%)
1320.0	277629	60.3%
1380.0	182927	39.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
1320.0	277629	60.3%
1380.0	182927	39.7%

Most occurring characters

Value	Count	Frequency (%)
0	921112	33.3%
1	460556	16.7%
3	460556	16.7%
.	460556	16.7%
2	277629	10.0%
8	182927	6.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2302780	83.3%
Other Punctuation	460556	16.7%

Most frequent character per category

Value	Count	Frequency (%)
0	921112	40.0%
1	460556	20.0%
3	460556	20.0%
2	277629	12.1%
8	182927	7.9%

Value	Count	Frequency (%)
.	460556	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2763336	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	921112	33.3%
1	460556	16.7%
3	460556	16.7%
.	460556	16.7%
2	277629	10.0%
8	182927	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2763336	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	921112	33.3%
1	460556	16.7%
3	460556	16.7%
.	460556	16.7%
2	277629	10.0%
8	182927	6.6%

month
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.028011794
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.363824047
Coefficient of variation (CV)	0.4786309622
Kurtosis	-1.025808663
Mean	7.028011794
Median Absolute Deviation (MAD)	3
Skewness	-0.2539622477
Sum	3236793
Variance	11.31531222
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	52306	11.4%
8	52264	11.3%
11	46759	10.2%
9	44758	9.7%
12	44203	9.6%
6	37634	8.2%
10	34778	7.6%
1	34383	7.5%
5	30283	6.6%
2	29254	6.4%
Other values (2)	53934	11.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	34383	7.5%
2	29254	6.4%
3	28694	6.2%
4	25240	5.5%
5	30283	6.6%

Value	Count	Frequency (%)
12	44203	9.6%
11	46759	10.2%
10	34778	7.6%
9	44758	9.7%
8	52264	11.3%

weekday
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.876770686
Minimum	0
Maximum	6
Zeros	73350
Zeros (%)	15.9%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.01769928
Coefficient of variation (CV)	0.701376474
Kurtosis	-1.187585179
Mean	2.876770686
Median Absolute Deviation (MAD)	2
Skewness	0.127768362
Sum	1324914
Variance	4.071110385
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	77800	16.9%
6	73860	16.0%
0	73350	15.9%
1	67433	14.6%
2	65637	14.3%
4	62733	13.6%
5	39743	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	73350	15.9%
1	67433	14.6%
2	65637	14.3%
3	77800	16.9%
4	62733	13.6%

Value	Count	Frequency (%)
6	73860	16.0%
5	39743	8.6%
4	62733	13.6%
3	77800	16.9%
2	65637	14.3%

hour
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

22.0	277629
23.0	182927

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1842224
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	22.0
2nd row	23.0
3rd row	23.0
4th row	23.0
5th row	23.0

Value	Count	Frequency (%)
22.0	277629	60.3%
23.0	182927	39.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
22.0	277629	60.3%
23.0	182927	39.7%

Most occurring characters

Value	Count	Frequency (%)
2	738185	40.1%
.	460556	25.0%
0	460556	25.0%
3	182927	9.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1381668	75.0%
Other Punctuation	460556	25.0%

Most frequent character per category

Value	Count	Frequency (%)
2	738185	53.4%
0	460556	33.3%
3	182927	13.2%

Value	Count	Frequency (%)
.	460556	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1842224	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	738185	40.1%
.	460556	25.0%
0	460556	25.0%
3	182927	9.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1842224	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	738185	40.1%
.	460556	25.0%
0	460556	25.0%
3	182927	9.9%

timesincelastevent
Real number (ℝ_≥0)

ZEROS

Distinct	2115
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	57343.91727
Minimum	0
Maximum	6078300
Zeros	141493
Zeros (%)	30.7%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	24420
Q3	86400
95-th percentile	187140
Maximum	6078300
Range	6078300
Interquartile range (IQR)	86400

Descriptive statistics

Standard deviation	118377.8676
Coefficient of variation (CV)	2.064349164
Kurtosis	423.534513
Mean	57343.91727
Median Absolute Deviation (MAD)	24420
Skewness	14.62238983
Sum	2.641008516 × 10¹⁰
Variance	1.401331955 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	141493	30.7%
86400	51301	11.1%
86460	16300	3.5%
10080	8156	1.8%
8640	8109	1.8%
1440	6888	1.5%
7200	6458	1.4%
11520	6253	1.4%
86340	6016	1.3%
12960	5599	1.2%
Other values (2105)	203983	44.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	141493	30.7%
1380	22	< 0.1%
1440	6888	1.5%
1500	18	< 0.1%
2820	26	< 0.1%

Value	Count	Frequency (%)
6078300	1	< 0.1%
6076860	1	< 0.1%
6061020	2	< 0.1%
5912700	1	< 0.1%
5863680	1	< 0.1%

timesincecasestart
Real number (ℝ_≥0)

ZEROS

Distinct	2793
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	125971.0222
Minimum	0
Maximum	6295680
Zeros	139927
Zeros (%)	30.4%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	99360
Q3	197340
95-th percentile	316860
Maximum	6295680
Range	6295680
Interquartile range (IQR)	197340

Descriptive statistics

Standard deviation	168723.8716
Coefficient of variation (CV)	1.339386382
Kurtosis	130.2035847
Mean	125971.0222
Median Absolute Deviation (MAD)	99360
Skewness	6.922687921
Sum	5.801671008 × 10¹⁰
Variance	2.846774486 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	139927	30.4%
1440	5530	1.2%
2880	4445	1.0%
4320	4219	0.9%
5760	3875	0.8%
7200	3781	0.8%
8640	3654	0.8%
86400	3199	0.7%
10080	2838	0.6%
198780	1630	0.4%
Other values (2783)	287458	62.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	139927	30.4%
1380	16	< 0.1%
1440	5530	1.2%
1500	14	< 0.1%
2820	19	< 0.1%

Value	Count	Frequency (%)
6295680	1	< 0.1%
6266880	1	< 0.1%
6251040	1	< 0.1%
6248160	1	< 0.1%
6220800	1	< 0.1%

event_nr
Real number (ℝ_≥0)

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.539135306
Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	20
Range	19
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.403700132
Coefficient of variation (CV)	0.5528260461
Kurtosis	1.28970217
Mean	2.539135306
Median Absolute Deviation (MAD)	1
Skewness	0.9225426208
Sum	1169414
Variance	1.97037406
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
1	129615	28.1%
2	129615	28.1%
3	83244	18.1%
4	80094	17.4%
5	23391	5.1%
6	11606	2.5%
7	1265	0.3%
8	983	0.2%
9	560	0.1%
10	89	< 0.1%
Other values (10)	94	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	129615	28.1%
2	129615	28.1%
3	83244	18.1%
4	80094	17.4%
5	23391	5.1%

Value	Count	Frequency (%)
20	1	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
17	3	< 0.1%
16	5	< 0.1%

open_cases
Real number (ℝ_≥0)

Distinct	3649
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10662.84286
Minimum	0
Maximum	17269
Zeros	16
Zeros (%)	< 0.1%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	5898
Q1	8987
median	10723
Q3	12407
95-th percentile	15581
Maximum	17269
Range	17269
Interquartile range (IQR)	3420

Descriptive statistics

Standard deviation	2924.895276
Coefficient of variation (CV)	0.2743072664
Kurtosis	0.7933714713
Mean	10662.84286
Median Absolute Deviation (MAD)	1719
Skewness	-0.4422451051
Sum	4910836254
Variance	8555012.374
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16492	1808	0.4%
12105	1554	0.3%
7509	1367	0.3%
10448	1319	0.3%
10356	1304	0.3%
12308	1296	0.3%
10352	1255	0.3%
11754	1136	0.2%
8759	1106	0.2%
12846	1103	0.2%
Other values (3639)	447308	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	< 0.1%
1	1	< 0.1%
5	4	< 0.1%
14	15	< 0.1%
15	23	< 0.1%

Value	Count	Frequency (%)
17269	26	< 0.1%
17268	37	< 0.1%
17266	16	< 0.1%
17264	31	< 0.1%
17261	63	< 0.1%

label
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

deviant	239478
regular	221078

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	3223892
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	deviant
2nd row	deviant
3rd row	deviant
4th row	deviant
5th row	regular

Value	Count	Frequency (%)
deviant	239478	52.0%
regular	221078	48.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
deviant	239478	52.0%
regular	221078	48.0%

Most occurring characters

Value	Count	Frequency (%)
e	460556	14.3%
a	460556	14.3%
r	442156	13.7%
d	239478	7.4%
v	239478	7.4%
i	239478	7.4%
n	239478	7.4%
t	239478	7.4%
g	221078	6.9%
u	221078	6.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3223892	100.0%

Most frequent character per category

Value	Count	Frequency (%)
e	460556	14.3%
a	460556	14.3%
r	442156	13.7%
d	239478	7.4%
v	239478	7.4%
i	239478	7.4%
n	239478	7.4%
t	239478	7.4%
g	221078	6.9%
u	221078	6.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3223892	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	460556	14.3%
a	460556	14.3%
r	442156	13.7%
d	239478	7.4%
v	239478	7.4%
i	239478	7.4%
n	239478	7.4%
t	239478	7.4%
g	221078	6.9%
u	221078	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3223892	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	460556	14.3%
a	460556	14.3%
r	442156	13.7%
d	239478	7.4%
v	239478	7.4%
i	239478	7.4%
n	239478	7.4%
t	239478	7.4%
g	221078	6.9%
u	221078	6.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	amount	org:resource	dismissal	concept:name	vehicleClass	totalPaymentAmount	lifecycle:transition	time:timestamp	article	case:concept:name	expense	notificationType	lastSent	paymentAmount	timesincemidnight	month	weekday	hour	timesincelastevent	timesincecasestart	event_nr	open_cases	label
0	35.0	561.0	NIL	Create Fine	A	0.0	complete	2006-08-01 22:00:00+00:00	157.0	A100	0.0	missing	missing	0.0	1320.0	8.0	1.0	22.0	0.0	0.0	1.0	11267.0	deviant
1	35.0	561.0	NIL	Send Fine	A	0.0	complete	2006-12-11 23:00:00+00:00	157.0	A100	11.0	missing	missing	0.0	1380.0	12.0	0.0	23.0	190140.0	190140.0	2.0	12351.0	deviant
2	35.0	561.0	NIL	Insert Fine Notification	A	0.0	complete	2007-01-14 23:00:00+00:00	157.0	A100	11.0	P	P	0.0	1380.0	1.0	6.0	23.0	48960.0	239100.0	3.0	12192.0	deviant
3	71.5	561.0	NIL	Add penalty	A	0.0	complete	2007-03-15 23:00:00+00:00	157.0	A100	11.0	P	P	0.0	1380.0	3.0	3.0	23.0	86400.0	325500.0	4.0	7762.0	deviant
4	36.0	561.0	NIL	Create Fine	A	0.0	complete	2007-03-08 23:00:00+00:00	157.0	A10000	0.0	missing	missing	0.0	1380.0	3.0	3.0	23.0	0.0	0.0	1.0	7765.0	regular
5	36.0	561.0	NIL	Send Fine	A	0.0	complete	2007-07-16 22:00:00+00:00	157.0	A10000	13.0	missing	missing	0.0	1320.0	7.0	0.0	22.0	187140.0	187140.0	2.0	9356.0	regular
6	36.0	561.0	NIL	Insert Fine Notification	A	0.0	complete	2007-08-01 22:00:00+00:00	157.0	A10000	13.0	P	P	0.0	1320.0	8.0	2.0	22.0	23040.0	210180.0	3.0	9859.0	regular
7	74.0	561.0	NIL	Add penalty	A	0.0	complete	2007-09-30 22:00:00+00:00	157.0	A10000	13.0	P	P	0.0	1320.0	9.0	6.0	22.0	86400.0	296580.0	4.0	10882.0	regular
8	74.0	561.0	NIL	Payment	A	87.0	complete	2008-09-08 22:00:00+00:00	157.0	A10000	13.0	P	P	87.0	1320.0	9.0	0.0	22.0	495360.0	791940.0	5.0	14487.0	regular
9	36.0	537.0	NIL	Create Fine	A	0.0	complete	2007-03-18 23:00:00+00:00	157.0	A10001	0.0	missing	missing	0.0	1380.0	3.0	6.0	23.0	0.0	0.0	1.0	7824.0	regular

Last rows

	amount	org:resource	dismissal	concept:name	vehicleClass	lifecycle:transition	time:timestamp	article	case:concept:name	expense	notificationType	lastSent	timesincemidnight	month	weekday	hour	timesincelastevent	timesincecasestart	event_nr	open_cases	label
460546	131.0	25.0	NIL	Insert Fine Notification	M	complete	2002-11-03 23:00:00+00:00	142.0	V9997	15.16	P	N	1380.0	11.0	6.0	23.0	14460.0	83580.0	3.0	12329.0	deviant
460547	262.0	25.0	NIL	Add penalty	M	complete	2003-01-02 23:00:00+00:00	142.0	V9997	15.16	P	N	1380.0	1.0	3.0	23.0	86400.0	169980.0	4.0	12326.0	deviant
460548	131.0	25.0	NIL	Create Fine	A	complete	2002-09-06 22:00:00+00:00	142.0	V9998	0.00	missing	missing	1320.0	9.0	4.0	22.0	0.0	0.0	1.0	12132.0	deviant
460549	131.0	25.0	NIL	Send Fine	A	complete	2002-10-24 22:00:00+00:00	142.0	V9998	10.00	missing	missing	1320.0	10.0	3.0	22.0	69120.0	69120.0	2.0	12308.0	deviant
460550	131.0	25.0	NIL	Insert Fine Notification	A	complete	2002-10-30 23:00:00+00:00	142.0	V9998	10.00	P	N	1380.0	10.0	2.0	23.0	8700.0	77820.0	3.0	12342.0	deviant
460551	262.0	25.0	NIL	Add penalty	A	complete	2002-12-29 23:00:00+00:00	142.0	V9998	10.00	P	N	1380.0	12.0	6.0	23.0	86400.0	164220.0	4.0	12324.0	deviant
460552	131.0	25.0	NIL	Create Fine	A	complete	2002-09-06 22:00:00+00:00	142.0	V9999	0.00	missing	missing	1320.0	9.0	4.0	22.0	0.0	0.0	1.0	12132.0	deviant
460553	131.0	25.0	NIL	Send Fine	A	complete	2002-10-24 22:00:00+00:00	142.0	V9999	15.16	missing	missing	1320.0	10.0	3.0	22.0	69120.0	69120.0	2.0	12308.0	deviant
460554	131.0	25.0	NIL	Insert Fine Notification	A	complete	2002-11-03 23:00:00+00:00	142.0	V9999	15.16	P	N	1380.0	11.0	6.0	23.0	14460.0	83580.0	3.0	12329.0	deviant
460555	262.0	25.0	NIL	Add penalty	A	complete	2003-01-02 23:00:00+00:00	142.0	V9999	15.16	P	N	1380.0	1.0	3.0	23.0	86400.0	169980.0	4.0	12326.0	deviant

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters